UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NPkPVRd9DyTlrf6bAeyjoysDS9z/zbliqUTegx/yJjw='
WHERE
key_id = 'f0741a1e8a93a718dcc72a3a9806f8191a727af028e01ca0f14d5861e044add8'
AND (
token = 'NPkPVRd9DyTlrf6bAeyjoysDS9z/zbliqUTegx/yJjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)