UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1gu+/go5ELBI0z29qSK38K/DECtw6ZIuAEU/pT7UuI='
WHERE
key_id = '330bf4272e350d5d398acc25e43e717f783ee1307a941017174c4fd127112ac3'
AND (
token = 'a1gu+/go5ELBI0z29qSK38K/DECtw6ZIuAEU/pT7UuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)