UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QTsNobtTElzMqC7wp8Axws08q3x5SZXF8K3pfZsrUsk='
WHERE
key_id = '8d24a23d43b33fd14448cd13d45b20c2e13e3b4af956ffd3b693a910d92cdba5'
AND (
token = 'QTsNobtTElzMqC7wp8Axws08q3x5SZXF8K3pfZsrUsk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)