UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SgHFn4OJpvfCzyk4d1JrqGM5B3NjiHmF1VjjCMFvmow='
WHERE
key_id = '918fbbd9fc82ba02df90e4546a56e0c7651144f40411a1959d9f43536fc09228'
AND (
token = 'SgHFn4OJpvfCzyk4d1JrqGM5B3NjiHmF1VjjCMFvmow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)