UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xaTL+kAUTJ10uXod612AD7IQApyYZQ6HLTyImeci248='
WHERE
key_id = '1f0345c9b7ff627235f1dcca6bc081cde9614cb02f988a1b2bee96d1bf248d58'
AND (
token = 'xaTL+kAUTJ10uXod612AD7IQApyYZQ6HLTyImeci248='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)