UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VTo85NoJXkFQ10+aW9s++oBUkL5qCBd28eYW+8dHtWw='
WHERE
key_id = '78c2fb30cfa6c9be3785f36915db1a6d3da477a4facca8b88a4454a46f28956a'
AND (
token = 'VTo85NoJXkFQ10+aW9s++oBUkL5qCBd28eYW+8dHtWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)