UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Iz8b774r3F618M1oY10+S3hUg5WXIHsld6sqLyF3iEI='
WHERE
key_id = 'df3d90234bb239146dc8f1620083d031fb8570fdd7dfe7a311c3dc42cb0aacdb'
AND (
token = 'Iz8b774r3F618M1oY10+S3hUg5WXIHsld6sqLyF3iEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)