UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+X0e8aW5f5AbXRNsEjENejUhyPmIN20tF2BJ50PFuZE='
WHERE
key_id = 'fc7af59d0f4bec26e2f80a1da7a554d6a0ff7e307084b0a637c6ee304ad4977f'
AND (
token = '+X0e8aW5f5AbXRNsEjENejUhyPmIN20tF2BJ50PFuZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)