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