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