UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rQ/+784G/D+nkWCQBn1l3ImBZS7DeaEm9WX/XvDwFqA='
WHERE
key_id = 'c2d04cffa5f12cd93f4f4e5ed2898ae27693423a99d4eef81be40a015c6abade'
AND (
token = 'rQ/+784G/D+nkWCQBn1l3ImBZS7DeaEm9WX/XvDwFqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)