UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qg8MGpjmMXZjH8nLo0u+xIbjGUEpCPp0opIv5AMjn4I='
WHERE
key_id = '28c447d6569e7117d4941f0834d3abf9d349af8d1dc18dab4b8ba3270b609fef'
AND (
token = 'Qg8MGpjmMXZjH8nLo0u+xIbjGUEpCPp0opIv5AMjn4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)