UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0YIkeEzTlWhPOtaTcrrEW4oknoMbXKnZlYI+9a7bDvg='
WHERE
key_id = 'ad6f7e7d893ef34c9488e9949f6457d1e10f3f8525bdb3373d5d1d525d8f262f'
AND (
token = '0YIkeEzTlWhPOtaTcrrEW4oknoMbXKnZlYI+9a7bDvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)