UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jd8XFvfebTQW4XOWhyaIsphwynw2NLP6Y8uYoaWA0Ww='
WHERE
key_id = 'd3151cb4eb2e163f1799f63a1dcec44853f9c41d2543447d0a39bb98d2899ad7'
AND (
token = 'Jd8XFvfebTQW4XOWhyaIsphwynw2NLP6Y8uYoaWA0Ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)