UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yqUveuydChOAd+B15hiNzt5mpWE1Q7iAa5SzhuS7yEA='
WHERE
key_id = '8b12941dacf97d1c2a7e66499e1f8d3f492d83c29409214116458e82430b5e03'
AND (
token = 'yqUveuydChOAd+B15hiNzt5mpWE1Q7iAa5SzhuS7yEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)