UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpTHacRhd9WScLj0mfRw+U4h+G2ToFkOL5UczesH4K8='
WHERE
key_id = 'c6f2de657c068767e7ba3fd2d45331ab00eb889755b887f5b6d9b78bb14c7e3f'
AND (
token = 'zpTHacRhd9WScLj0mfRw+U4h+G2ToFkOL5UczesH4K8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)