UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5X16ifqmVRI6TqYBHbG91xdX3qSqrZDV+Wy9QLc/PY='
WHERE
key_id = 'd2e71ee7d4705037a8fac370f0383dc94c9005bfb8e4466266ff3d08613d3bad'
AND (
token = 'X5X16ifqmVRI6TqYBHbG91xdX3qSqrZDV+Wy9QLc/PY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)