UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bopDwbGfyHf5y3i4sXe62QHCX7V0Na2D8Znlr6YkywU='
WHERE
key_id = 'c8e84e4fe70eab343a46b692b2be8dc7be1a68b673eb3bbd505efb240e64b1ea'
AND (
token = 'bopDwbGfyHf5y3i4sXe62QHCX7V0Na2D8Znlr6YkywU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)