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