UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8JBNinvBZ1DeruTgH0bA+DF2WuWpNTc/icZNed3dNI='
WHERE
key_id = 'd24ae374b04cce3b91863728079722c0e9649e40d698a1bd433f30cd30a7c887'
AND (
token = 'N8JBNinvBZ1DeruTgH0bA+DF2WuWpNTc/icZNed3dNI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)