UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXSRowBT3Nfzqkb4Uf1SAHTanynRAD8rHUWHaAIDiV4='
WHERE
key_id = '872e6735581e84da19dcdd13c62e064e037b6065047bf112e4891e2f9de722fa'
AND (
token = 'mXSRowBT3Nfzqkb4Uf1SAHTanynRAD8rHUWHaAIDiV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)