UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A8OcnzSG8FwTLX9hPRQcigNdOIheRwg9oJV9+jf5hgE='
WHERE
key_id = '70a11cf6e823fbf05cc754e9e83d1138b1b587c675f92488756d8a062d2d640e'
AND (
token = 'A8OcnzSG8FwTLX9hPRQcigNdOIheRwg9oJV9+jf5hgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)