UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ja8GS0mLn7oGg1L/phvHszV0AicEDdzfAFbxjT4yiYo='
WHERE
key_id = 'f74c7a34f110953299dd3a0c83288bd6a0186d5c24394249e095a43fcd09c34a'
AND (
token = 'ja8GS0mLn7oGg1L/phvHszV0AicEDdzfAFbxjT4yiYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)