UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bi0ICFdnMapjabqfEXW3HL4GqaoZBuv/YacvHRO2dmA='
WHERE
key_id = 'b62f815b73146372bdec83150767640d1b76a63701ee1251ebaa7466df7dd96a'
AND (
token = 'Bi0ICFdnMapjabqfEXW3HL4GqaoZBuv/YacvHRO2dmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)