UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k9/ot+827ESF2huyZ3WX+hSNKBnypnPA1uo9Nh6+yd0='
WHERE
key_id = '3946e1e27984cd7c2518cfced95f154402ecbaf82cf0ad4f7d689d6ab0460843'
AND (
token = 'k9/ot+827ESF2huyZ3WX+hSNKBnypnPA1uo9Nh6+yd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)