UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KxAdnhgrc+oCa1jcP7U6zxXbLE+xTXd/UnEPw4dDHuk='
WHERE
key_id = '67207e6675f5304f09f18dec9d1869963b7994278526eabbbfcfc90e49dffda7'
AND (
token = 'KxAdnhgrc+oCa1jcP7U6zxXbLE+xTXd/UnEPw4dDHuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)