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