UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3VHbJAIYkOee0DdBBfv7WYVFbLROSPLJAQYCPA14TqU='
WHERE
key_id = '477d4cd5b0d48a756f8ef9ce8b3420407b429b6e35ab8445545f2aedc115435f'
AND (
token = '3VHbJAIYkOee0DdBBfv7WYVFbLROSPLJAQYCPA14TqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)