UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SFm8GW7zdj+vhwbwCxBcnRH4APrL6VbIZ+51uDsAZZA='
WHERE
key_id = '1706177110f95a9bdbe759a49aea6cefb1a2fb90c8251d07b0a695d62f730042'
AND (
token = 'SFm8GW7zdj+vhwbwCxBcnRH4APrL6VbIZ+51uDsAZZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)