UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LxGPpFo5l2iYyhmc867oGgFHh7Cvz+y5co0rCWMi95A='
WHERE
key_id = '1c6b0f7af43a0de0975a70c1910083480f283f9345333e784365b7f9a675f666'
AND (
token = 'LxGPpFo5l2iYyhmc867oGgFHh7Cvz+y5co0rCWMi95A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)