UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zDYwhgzTXGkiDUFCmKsWhkYpUlfktOkcfEEe3vUL8c='
WHERE
key_id = '3de025dd5c926c55e70a0413c9e921ce9f7043f8442cca9fb78e1f1192707fea'
AND (
token = '6zDYwhgzTXGkiDUFCmKsWhkYpUlfktOkcfEEe3vUL8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)