UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HktSNn4tTN6vdDGl3mpm6cE+uaFb2uV8TBYYtr3dhTE='
WHERE
key_id = '0f642173ad8086142936ccfb9edadb22c2a236f8c3851b5243805ba78a90813d'
AND (
token = 'HktSNn4tTN6vdDGl3mpm6cE+uaFb2uV8TBYYtr3dhTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)