UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wT1AY9R9gymEx9EF+7SU8EGW1fMXOtRbVViwC2p1QUs='
WHERE
key_id = 'cd19678117b08c7189591ac005ccedd309b619b196485b0c21c5c0a7bbb90ba7'
AND (
token = 'wT1AY9R9gymEx9EF+7SU8EGW1fMXOtRbVViwC2p1QUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)