UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cn6lXsW2UxxFpPLCxpXnL/gYmG5r7bneRnv9omTt81c='
WHERE
key_id = 'd0faae34f8e74a2a2b089bfef83256c540d853555ef4314ec0575080be1f2ce7'
AND (
token = 'cn6lXsW2UxxFpPLCxpXnL/gYmG5r7bneRnv9omTt81c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)