UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ppN0hIkNiRJwP8VRNSBdEojudU/6MEO5ry1If5okf18='
WHERE
key_id = 'c9e0892afbac639aba3069d9ca22f77f66dbd5e90e7905714a58fc7aa095ab49'
AND (
token = 'ppN0hIkNiRJwP8VRNSBdEojudU/6MEO5ry1If5okf18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)