UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P9s9HFAc2Ze8JSTLk67wV2JbDAkvGCAhda8fRJ3e95s='
WHERE
key_id = '945aa1cb198438fb36c3ba2e8e04d335daebf986c5e963ad051a36ee2a5b0173'
AND (
token = 'P9s9HFAc2Ze8JSTLk67wV2JbDAkvGCAhda8fRJ3e95s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)