UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8kEGX/jkT93YnfHD/rfjvCFCiAd8ZFmYGFt9tgZ+f0Q='
WHERE
key_id = '7de3337ed0bbad564b57dc3b2d068029cd3f671f60ad4242fe082e3b8b7df46e'
AND (
token = '8kEGX/jkT93YnfHD/rfjvCFCiAd8ZFmYGFt9tgZ+f0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)