UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qr1pfn6c269w/6uo8eLoUt70GJER0I28v7QloReUUqw='
WHERE
key_id = '7d7d9f1c30c87e630a038384c35ca4262ccf2b0309a09761d11b67421c8d6147'
AND (
token = 'Qr1pfn6c269w/6uo8eLoUt70GJER0I28v7QloReUUqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)