UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Px3zr1GzYZ/25qLRjEVLU580TSpH4n8kNG3LlD9rNU='
WHERE
key_id = 'a0f674694391738264356b3ac3c58c316b7105af762f04504586a3f074328a15'
AND (
token = '8Px3zr1GzYZ/25qLRjEVLU580TSpH4n8kNG3LlD9rNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)