UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dW29J8UCloK/PIFcqwAmYSQP2ibraCzr7Va4hE6dk6Q='
WHERE
key_id = '7770e56dced47f541584120c92c4e27d47eb19cb8ecb50a23cb34be8b1dae04c'
AND (
token = 'dW29J8UCloK/PIFcqwAmYSQP2ibraCzr7Va4hE6dk6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)