UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KKNr3vxnh3qTO0B0BhEfAvQm1UY/ESrDzV8z0dsK0gM='
WHERE
key_id = '7caf0935bd60826e786f0ed624b776659a1e88c7b5ddc4f66b59437f21978986'
AND (
token = 'KKNr3vxnh3qTO0B0BhEfAvQm1UY/ESrDzV8z0dsK0gM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)