UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6P5412DsD4yobT4YLAtNKGrJqLaS2R83WGVP1+jW6RM='
WHERE
key_id = 'dbe18ce9b9a0c84e0c34c5cb5f15cd92afc1473fefa31e6fc51964d8e0521bfb'
AND (
token = '6P5412DsD4yobT4YLAtNKGrJqLaS2R83WGVP1+jW6RM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)