UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '60DrPqu+olbhOTtytri86uqbwCKedg7BR96pXk8gtbA='
WHERE
key_id = 'd0188c8bc1aca9ae267cae79f4cf346aa5e75425c010f6a1ddcc590c8b5fc99d'
AND (
token = '60DrPqu+olbhOTtytri86uqbwCKedg7BR96pXk8gtbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)