UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qKUKPGLZitxavk0ELVDXxNHKe2bSUImfBhiDERSi+UI='
WHERE
key_id = '14910f55d1ec2aaabda317ccd124249efdf7a0c21e4c573588e311bf8e9b8ec8'
AND (
token = 'qKUKPGLZitxavk0ELVDXxNHKe2bSUImfBhiDERSi+UI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)