UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kPXJZ1uZ1ve2SI5rXE1dHtrC9wBlMpt7CbtzqZbQnIU='
WHERE
key_id = '67ada196da573afed3131448556fdf80ca9e4e743b4a0ba3e1faae9758ba6565'
AND (
token = 'kPXJZ1uZ1ve2SI5rXE1dHtrC9wBlMpt7CbtzqZbQnIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)