UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U+LvVtEBB1ReVvhkJKCM0S6y/whjjoFRliQ04taxnuc='
WHERE
key_id = 'f5b1ad3c7fc83af9356563ad5e271fba368680ebfe4c5aeac0c55772e7c102fe'
AND (
token = 'U+LvVtEBB1ReVvhkJKCM0S6y/whjjoFRliQ04taxnuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)