UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PvBefN4YUkbJXv7Mf1iToHAf5b9tQ+ijr31/9HO90f8='
WHERE
key_id = 'dc3c649f5208a6d8b92899eb39157b47d32b58899bcb81fd6ac41e85214cc30a'
AND (
token = 'PvBefN4YUkbJXv7Mf1iToHAf5b9tQ+ijr31/9HO90f8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)