UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oIi0HFEedqTsF4ElLhJhS06WU9tbP4wJLSTlBBjA98A='
WHERE
key_id = 'd4bd3916e745a445277d2fad61b73e6d24f7c5ac63dae4e59d60309ec1fb2e0f'
AND (
token = 'oIi0HFEedqTsF4ElLhJhS06WU9tbP4wJLSTlBBjA98A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)