UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OG5ghJ3IuegiugmES3dD7Y6cNWzlziOMfAUKmMUEsVw='
WHERE
key_id = '1c31ac58bf22bce07b1a11ccbe6adf7fadd356f47eb3ea20471f44a85e584b9b'
AND (
token = 'OG5ghJ3IuegiugmES3dD7Y6cNWzlziOMfAUKmMUEsVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)